Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CHANGE_SOURCES

`CHANGE_SOURCES` describes existing change sources. The user must have the `SELECT_CATALOG_ROLE` privilege to access this view. This view is intended for use by Change Data Capture publishers.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SOURCE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of change source
`DBID` | `NUMBER` |  | Reserved for future use
`LOG_DIRECTORY` | `VARCHAR2(2000)` |  | Reserved for future use
`LOGFILE_PATTERN` | `VARCHAR2(30)` |  | Reserved for future use
`SOURCE_DESCRIPTION` | `VARCHAR2(255)` |  | Comment field for customers
`CREATED` | `DATE` | `NOT NULL` | Creation date of the change source
`SOURCE_TYPE` | `VARCHAR2(18)` |  | Change source capture mode: `AUTOLOG` `HOTLOG` `SYNCHRONOUS` `DISTRIBUTED HOTLOG` `AUTOLOG ONLINE`
`SOURCE_DATABASE` | `VARCHAR2(128)` |  | Global name of the source database
`FIRST_SCN` | `NUMBER` |  | SCN of a LogMiner dictionary at which capture can begin
`PUBLISHER` | `VARCHAR2(30)` |  | Publisher of the change source
`CAPTURE_NAME` | `VARCHAR2(30)` |  | Name of Streams capture process
`CAPTURE_QUEUE_NAME` | `VARCHAR2(30)` |  | Name of Streams capture queue
`CAPTURE_QUEUE_TABLE_NAME` | `VARCHAR2(30)` |  | Name of Streams capture queue table
`SOURCE_ENABLED` | `VARCHAR2(1)` |  | Whether or not source is enabled